<html>
<body>
This script removes zeroes from the Agency Feedback entries where it would violate FK constraints.<BR>
<?php 
$max_runtime = 6000;

echo "Maximum script runtime set to ".$max_runtime." seconds.<BR>";
set_time_limit($max_runtime);
//error_reporting('IGNORE_REPEATED_ERRORS');


$conn = mysql_connect ("localhost", "root", "") or die ('Error: ' . mysql_error());
$db = mysql_select_db("QA");

$query_string = "update QA.AgencyFeedback Set Contacted=1 where Contacted=0;";
$select_results = mysql_query($query_string);
$query_string = "update QA.AgencyFeedback Set Time=1 where Time=0;";
$select_results = mysql_query($query_string);
$query_string = "update QA.AgencyFeedback Set Assistance=1 where Assistance=0;";
$select_results = mysql_query($query_string);
$query_string = "update QA.AgencyFeedback Set Treated=1 where Treated=0;";
$select_results = mysql_query($query_string);


?><BR>

</body>
</html>